.. _`Pivot Table`:

.. _`org.sysess.sympathy.data.table.pivottablenode`:

Pivot Table
~~~~~~~~~~~

.. image:: pivot_table.svg
   :width: 48






**Documentation**




**Definition**


*Input ports*

    :Input:  table

        Input Table


*Output ports*

    :Output:  table

        Output Table



*Configuration*:
    **Index column** (index)
        Column that contains a unique identifier for each new row
    **Column names column** (columns)
        Column that contains the new column names
    **Value column** (values)
        Column that contains the new values
    **Use zeros/empty strings instead of masks** (nomasks)
        When unchecked any positions in the output which arn't mentioned in the input will be masked. When checked such positions are instead assigned a zero value, an empty string, or some other value depending on the type of the values column.
    **Include index column** (include_index)
        Include a column with the index of each row.

.. automodule:: node_pivot_table
    :noindex:

.. class:: PivotTable
    :noindex:






**Example flows**

* :download:`PivotTable.syx </_examples/Sympathy/Data Processing/Structure/PivotTable.syx>`